This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
RE: Compare 2 dates ~Umberto Nongeroson 24.Dec.03 02:34 PM a Web browser Domino Designer 6.0.1All Platforms
First, you need to find out exactly what value -- and what datatype of value -- is in that field. Use the Document Properties dialog from a view to examine the field value.
Rod's formula looks OK to me -- it assumes that dates are formatted dd/mm/yyyy on your computer, but based on your original posting it looks like they are. Are you sure you didn't leave out the square brackets or anything?
You might try putting in some debugging code so that you can tell which part of the expression is failing. E.g.:
Also, you said that it's a "computed" field. Did you know that computed fields are not recalculated when opening an existing document? Only when you edit the document, and refresh or save it, will Notes display a new value. The debugging code will also help you to determine when the formula is actually being evaluated.